
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspSiteContent_UPDATE]
(
@parentSiteContentId int = null,
@siteContentId int = null,
@title nvarchar(150) = null,
@content nvarchar(MAX) = null,
@contentTypeCode int = null,
@isDeleted bit = null,
@isVisible bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[SiteContent]
SET
  [ParentSiteContentId] = @parentSiteContentId,
  [Title] = @title,
  [Content] = @content,
  [ContentTypeCode] = @contentTypeCode,
  [IsDeleted] = @isDeleted,
  [IsVisible] = @isVisible,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [SiteContentId] = @siteContentId

GO
